package com.appsl.persistance;

import java.util.ArrayList;
import java.util.List;

import com.appsl.objects.Lugar;

import android.database.sqlite.SQLiteDatabase;

public class DML 
{
	public static void updateDatabase(SQLiteDatabase db) 
	{			
		List<Lugar> lstLocation = new ArrayList<Lugar>();
		lstLocation.add(new Lugar(1, "Jockey Plaza", "-12.084394", "-76.978436", "Av Javier Prado 5022"));
		lstLocation.add(new Lugar(2, "Open Plaza Angamos", "-12.1112015", "-77.0118596", "Av Rodrigo Merino 125"));
		lstLocation.add(new Lugar(3, "Plaza San Miguel", "-12.0836948", "-76.9778571", "Av Juan Carlos Gomez 2241"));
		lstLocation.add(new Lugar(4, "Real Plaza", "-12.1112015", "-77.0118596", "Av Tomas Marsano 4029"));
		lstLocation.add(new Lugar(5, "Larcomar", "-12.1112015", "-77.0118596", "Av Tomas Marsano 4029"));
		lstLocation.add(new Lugar(6, "Primavera", "-12.1112015", "-77.0118596", "Av La Molina 1151"));
		lstLocation.add(new Lugar(7, "Molina Plaza", "-12.0822562", "-76.9722245", "Av La Molina 1151"));
		lstLocation.add(new Lugar(8, "La Rambla", "-12.0806395", "-76.9704013", "Av Las Palmeras 1521"));
		lstLocation.add(new Lugar(9, "Plaza Lima Norte", "-12.1112015", "-77.0118596", "Av Tomas Marsano 4029"));
		lstLocation.add(new Lugar(10, "Plaza Lima Sur", "-12.1112015", "-77.0118596", "Av Tomas Marsano 4029"));
		lstLocation.add(new Lugar(11, "C.C. Camino Real", "-12.1112015", "-77.0118596", "Av Tomas Marsano 4029"));
		lstLocation.add(new Lugar(12, "C.C. Caminos del Inca", "-12.1112015", "-77.0118596", "Av Tomas Marsano 4029"));
		//lstLocation.add(new Lugar(3, "Pabellon V PUCP", "-12.0731099", "-77.0819087", "Av Universitaria 1801"));
		
		for (Lugar loc : lstLocation)
			DDL.mergeLugar(db, loc);
	}
}